
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Gets all records from the Hospital table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Hospital_Get_List

AS


				
				SELECT
					[Id],
					[LocalId],
					[Title],
					[Alias],
					[Introduction],
					[Thumbnail],
					[ClinicTime],
					[Contact],
					[CreatedDate],
					[UpdatedDate],
					[CreatedUser],
					[UpdatedUser]
				FROM
					[dbo].[Hospital]
					
				SELECT @@ROWCOUNT
			

GO
